Computer Science for IGCSE & O level - Databases (Section 6 - No. 42)
What is a foreign key used for?
To uniquely identify records in a table.
To establish a relationship between two tables.
To ensure data integrity.
To speed up data retrieval.
Forklaring
A foreign key establishes a connection between tables and ensures data consistency by referencing the primary key of another table.